Tabela PhInventoryItem

Definicja tabeli PhInventoryItem

Name

PhInventoryItem

Code

PhInventoryItem

Comment

Elementy remanentu


Lista kolumn tabeli PhInventoryItem

Name

Code

InventoryItemID

InventoryItemID

InventoryID

InventoryID

LotID

LotID

PresentationUnitID

PresentationUnitID

LP

LP

StockQuantity

StockQuantity

SystemQuantity

SystemQuantity

StockItemID

StockItemID

ValueGross

ValueGross

StockValueGross

StockValueGross

StockDocumentItemId

StockDocumentItemId

InventoryDiffTypeID

InventoryDiffTypeID


Kolumna InventoryItemID tabeli PhInventoryItem

Definicja kolumny InventoryItemID tabeli PhInventoryItem

Name

InventoryItemID

Code

InventoryItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InventoryID tabeli PhInventoryItem

Definicja kolumny InventoryID tabeli PhInventoryItem

Name

InventoryID

Code

InventoryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LotID tabeli PhInventoryItem

Definicja kolumny LotID tabeli PhInventoryItem

Name

LotID

Code

LotID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PresentationUnitID tabeli PhInventoryItem

Definicja kolumny PresentationUnitID tabeli PhInventoryItem

Name

PresentationUnitID

Code

PresentationUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Informacja o jednostce w której prezentowana jest pozycja remanentu


Kolumna LP tabeli PhInventoryItem

Definicja kolumny LP tabeli PhInventoryItem

Name

LP

Code

LP

Data Type

NUMBER(19)

Mandatory

No

Comment

Liczba porzadkowa


Kolumna StockQuantity tabeli PhInventoryItem

Definicja kolumny StockQuantity tabeli PhInventoryItem

Name

StockQuantity

Code

StockQuantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc rzeczywista


Kolumna SystemQuantity tabeli PhInventoryItem

Definicja kolumny SystemQuantity tabeli PhInventoryItem

Name

SystemQuantity

Code

SystemQuantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc w systemie


Kolumna StockItemID tabeli PhInventoryItem

Definicja kolumny StockItemID tabeli PhInventoryItem

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID asortymentu


Kolumna ValueGross tabeli PhInventoryItem

Definicja kolumny ValueGross tabeli PhInventoryItem

Name

ValueGross

Code

ValueGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

 


Kolumna StockValueGross tabeli PhInventoryItem

Definicja kolumny StockValueGross tabeli PhInventoryItem

Name

StockValueGross

Code

StockValueGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

 


Kolumna StockDocumentItemId tabeli PhInventoryItem

Definicja kolumny StockDocumentItemId tabeli PhInventoryItem

Name

StockDocumentItemId

Code

StockDocumentItemId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InventoryDiffTypeID tabeli PhInventoryItem

Definicja kolumny InventoryDiffTypeID tabeli PhInventoryItem

Name

InventoryDiffTypeID

Code

InventoryDiffTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator powodu róznicy remanentowej


Lista kluczy tabeli PhInventoryItem

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhInventoryItem

Definicja klucza Key_1 tabeli PhInventoryItem

Name

Key_1

Code

Key_1

Primary

Yes

Comment